﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[proc_zzjg_GetItem]
	(
	@id int	
	)
AS
BEGIN	
    
   
	SELECT ManagementArea.Id, zid, CompanyName, Startletter, CompanyPhone, CompanyFax,
	       CompanyAddress, Zip, ContactPerson, ContactPhone, ContactEmail,
	       WebAddress, Products   ,z.sort
	  FROM ManagementArea,Zzjg z WHERE z.id=@id AND ManagementArea.zid=z.bh
	
END
